Overview
Brought to you by YData
Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 500 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 195.8 KiB |
| Average record size in memory | 401.0 B |
Variable types
| Text | 2 |
|---|---|
| Categorical | 5 |
| Numeric | 7 |
Store has constant value "1" | Constant |
Brand is highly overall correlated with Classification and 1 other fields | High correlation |
Classification is highly overall correlated with Brand and 3 other fields | High correlation |
ExciseTax is highly overall correlated with SalesDollars and 1 other fields | High correlation |
SalesDollars is highly overall correlated with ExciseTax and 2 other fields | High correlation |
SalesPrice is highly overall correlated with SalesDollars | High correlation |
SalesQuantity is highly overall correlated with ExciseTax and 1 other fields | High correlation |
Size is highly overall correlated with Classification and 2 other fields | High correlation |
VendorName is highly overall correlated with Brand and 4 other fields | High correlation |
VendorNo is highly overall correlated with VendorName | High correlation |
Volume is highly overall correlated with Classification and 2 other fields | High correlation |
Size is highly imbalanced (64.4%) | Imbalance |
Reproduction
| Analysis started | 2025-09-25 08:06:47.617834 |
|---|---|
| Analysis finished | 2025-09-25 08:07:00.120486 |
| Duration | 12.5 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
InventoryId
Text
| Distinct | 95 |
|---|---|
| Distinct (%) | 19.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.7 KiB |
Length
| Max length | 20 |
|---|---|
| Median length | 20 |
| Mean length | 19.756 |
| Min length | 18 |
Unique
| Unique | 22 ? |
|---|---|
| Unique (%) | 4.4% |
Sample
| 1st row | 1_HARDERSFIELD_1004 |
|---|---|
| 2nd row | 1_HARDERSFIELD_1004 |
| 3rd row | 1_HARDERSFIELD_1004 |
| 4th row | 1_HARDERSFIELD_1004 |
| 5th row | 1_HARDERSFIELD_1005 |
| Value | Count | Frequency (%) |
| 1_hardersfield_11219 | 22 | 4.4% |
| 1_hardersfield_1180 | 17 | 3.4% |
| 1_hardersfield_10727 | 15 | 3.0% |
| 1_hardersfield_11825 | 14 | 2.8% |
| 1_hardersfield_11826 | 14 | 2.8% |
| 1_hardersfield_11141 | 13 | 2.6% |
| 1_hardersfield_10062 | 13 | 2.6% |
| 1_hardersfield_11698 | 12 | 2.4% |
| 1_hardersfield_10626 | 12 | 2.4% |
| 1_hardersfield_11828 | 12 | 2.4% |
| Other values (85) | 356 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1359 | |
| _ | 1000 | |
| D | 1000 | |
| R | 1000 | |
| E | 1000 | |
| H | 500 | 5.1% |
| A | 500 | 5.1% |
| S | 500 | 5.1% |
| F | 500 | 5.1% |
| I | 500 | 5.1% |
| Other values (10) | 2019 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9878 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1359 | |
| _ | 1000 | |
| D | 1000 | |
| R | 1000 | |
| E | 1000 | |
| H | 500 | 5.1% |
| A | 500 | 5.1% |
| S | 500 | 5.1% |
| F | 500 | 5.1% |
| I | 500 | 5.1% |
| Other values (10) | 2019 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9878 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1359 | |
| _ | 1000 | |
| D | 1000 | |
| R | 1000 | |
| E | 1000 | |
| H | 500 | 5.1% |
| A | 500 | 5.1% |
| S | 500 | 5.1% |
| F | 500 | 5.1% |
| I | 500 | 5.1% |
| Other values (10) | 2019 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9878 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 1359 | |
| _ | 1000 | |
| D | 1000 | |
| R | 1000 | |
| E | 1000 | |
| H | 500 | 5.1% |
| A | 500 | 5.1% |
| S | 500 | 5.1% |
| F | 500 | 5.1% |
| I | 500 | 5.1% |
| Other values (10) | 2019 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 500 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 500 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 500 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 500 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 500 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 500 |
Brand
Real number (ℝ)
High correlation
| Distinct | 95 |
|---|---|
| Distinct (%) | 19.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8709.88 |
| Minimum | 115 |
|---|---|
| Maximum | 11888 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 115 |
|---|---|
| 5-th percentile | 1019.95 |
| Q1 | 10062 |
| median | 10603 |
| Q3 | 11219 |
| 95-th percentile | 11826 |
| Maximum | 11888 |
| Range | 11773 |
| Interquartile range (IQR) | 1157 |
Descriptive statistics
| Standard deviation | 4170.3728 |
|---|---|
| Coefficient of variation (CV) | 0.47880945 |
| Kurtosis | -0.27141052 |
| Mean | 8709.88 |
| Median Absolute Deviation (MAD) | 613.5 |
| Skewness | -1.2816317 |
| Sum | 4354940 |
| Variance | 17392010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11219 | 22 | 4.4% |
| 1180 | 17 | 3.4% |
| 10727 | 15 | 3.0% |
| 11825 | 14 | 2.8% |
| 11826 | 14 | 2.8% |
| 11141 | 13 | 2.6% |
| 10062 | 13 | 2.6% |
| 11698 | 12 | 2.4% |
| 10626 | 12 | 2.4% |
| 11828 | 12 | 2.4% |
| Other values (85) | 356 |
| Value | Count | Frequency (%) |
| 115 | 10 | |
| 1004 | 4 | 0.8% |
| 1005 | 4 | 0.8% |
| 1006 | 1 | 0.2% |
| 1009 | 1 | 0.2% |
| 1012 | 1 | 0.2% |
| 1013 | 2 | 0.4% |
| 1019 | 2 | 0.4% |
| 1020 | 1 | 0.2% |
| 1021 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 11888 | 5 | 1.0% |
| 11828 | 12 | |
| 11827 | 7 | |
| 11826 | 14 | |
| 11825 | 14 | |
| 11771 | 1 | 0.2% |
| 11698 | 12 | |
| 11488 | 4 | 0.8% |
| 11480 | 1 | 0.2% |
| 11456 | 2 | 0.4% |
Description
Text
| Distinct | 93 |
|---|---|
| Distinct (%) | 18.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 35.2 KiB |
Length
| Max length | 28 |
|---|---|
| Median length | 25 |
| Mean length | 22.822 |
| Min length | 10 |
Unique
| Unique | 22 ? |
|---|---|
| Unique (%) | 4.4% |
Sample
| 1st row | Jim Beam w/2 Rocks Glasses |
|---|---|
| 2nd row | Jim Beam w/2 Rocks Glasses |
| 3rd row | Jim Beam w/2 Rocks Glasses |
| 4th row | Jim Beam w/2 Rocks Glasses |
| 5th row | Maker's Mark Combo Pack |
| Value | Count | Frequency (%) |
| svgn | 138 | 6.8% |
| cab | 78 | 3.9% |
| bl | 60 | 3.0% |
| pnt | 51 | 2.5% |
| cupcake | 47 | 2.3% |
| nr | 45 | 2.2% |
| chard | 41 | 2.0% |
| cal | 35 | 1.7% |
| b | 30 | 1.5% |
| williams | 29 | 1.4% |
| Other values (244) | 1463 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1517 | 13.3% | |
| a | 1051 | 9.2% |
| e | 736 | 6.4% |
| o | 694 | 6.1% |
| l | 659 | 5.8% |
| r | 623 | 5.5% |
| n | 620 | 5.4% |
| i | 456 | 4.0% |
| s | 394 | 3.5% |
| C | 391 | 3.4% |
| Other values (53) | 4270 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11411 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1517 | 13.3% | |
| a | 1051 | 9.2% |
| e | 736 | 6.4% |
| o | 694 | 6.1% |
| l | 659 | 5.8% |
| r | 623 | 5.5% |
| n | 620 | 5.4% |
| i | 456 | 4.0% |
| s | 394 | 3.5% |
| C | 391 | 3.4% |
| Other values (53) | 4270 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11411 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1517 | 13.3% | |
| a | 1051 | 9.2% |
| e | 736 | 6.4% |
| o | 694 | 6.1% |
| l | 659 | 5.8% |
| r | 623 | 5.5% |
| n | 620 | 5.4% |
| i | 456 | 4.0% |
| s | 394 | 3.5% |
| C | 391 | 3.4% |
| Other values (53) | 4270 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11411 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1517 | 13.3% | |
| a | 1051 | 9.2% |
| e | 736 | 6.4% |
| o | 694 | 6.1% |
| l | 659 | 5.8% |
| r | 623 | 5.5% |
| n | 620 | 5.4% |
| i | 456 | 4.0% |
| s | 394 | 3.5% |
| C | 391 | 3.4% |
| Other values (53) | 4270 |
Size
Categorical
High correlation Imbalance
| Distinct | 13 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.5 KiB |
| 750mL | |
|---|---|
| 1.5L | |
| 1.75L | 21 |
| Liter | 16 |
| 5L | 9 |
| Other values (8) | 18 |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 5.03 |
| Min length | 2 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | 750mL |
|---|---|
| 2nd row | 750mL |
| 3rd row | 750mL |
| 4th row | 750mL |
| 5th row | 375mL 2 Pk |
Common Values
| Value | Count | Frequency (%) |
| 750mL | 391 | |
| 1.5L | 45 | 9.0% |
| 1.75L | 21 | 4.2% |
| Liter | 16 | 3.2% |
| 5L | 9 | 1.8% |
| 200mL 3 Pk | 4 | 0.8% |
| 375mL 2 Pk | 4 | 0.8% |
| 750mL + 3/ | 3 | 0.6% |
| 50mL 3 Pk | 2 | 0.4% |
| 100mL 4 Pk | 2 | 0.4% |
| Other values (3) | 3 | 0.6% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 750ml | 395 | |
| 1.5l | 45 | 8.4% |
| 1.75l | 21 | 3.9% |
| liter | 16 | 3.0% |
| pk | 15 | 2.8% |
| 3 | 11 | 2.1% |
| 5l | 9 | 1.7% |
| 375ml | 5 | 0.9% |
| 200ml | 4 | 0.7% |
| 2 | 4 | 0.7% |
| Other values (4) | 11 | 2.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 500 | |
| 5 | 478 | |
| 7 | 421 | |
| 0 | 410 | |
| m | 409 | |
| 1 | 68 | 2.7% |
| . | 66 | 2.6% |
| 36 | 1.4% | |
| i | 16 | 0.6% |
| e | 16 | 0.6% |
| Other values (9) | 95 | 3.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2515 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 500 | |
| 5 | 478 | |
| 7 | 421 | |
| 0 | 410 | |
| m | 409 | |
| 1 | 68 | 2.7% |
| . | 66 | 2.6% |
| 36 | 1.4% | |
| i | 16 | 0.6% |
| e | 16 | 0.6% |
| Other values (9) | 95 | 3.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2515 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 500 | |
| 5 | 478 | |
| 7 | 421 | |
| 0 | 410 | |
| m | 409 | |
| 1 | 68 | 2.7% |
| . | 66 | 2.6% |
| 36 | 1.4% | |
| i | 16 | 0.6% |
| e | 16 | 0.6% |
| Other values (9) | 95 | 3.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2515 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 500 | |
| 5 | 478 | |
| 7 | 421 | |
| 0 | 410 | |
| m | 409 | |
| 1 | 68 | 2.7% |
| . | 66 | 2.6% |
| 36 | 1.4% | |
| i | 16 | 0.6% |
| e | 16 | 0.6% |
| Other values (9) | 95 | 3.8% |
SalesQuantity
Real number (ℝ)
High correlation
| Distinct | 14 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.064 |
| Minimum | 1 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 6 |
| Maximum | 36 |
| Range | 35 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.5606675 |
|---|---|
| Coefficient of variation (CV) | 1.2406335 |
| Kurtosis | 66.483286 |
| Mean | 2.064 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.431217 |
| Sum | 1032 |
| Variance | 6.557018 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 1 | 303 | |
| 2 | 107 | 21.4% |
| 3 | 28 | 5.6% |
| 4 | 23 | 4.6% |
| 6 | 12 | 2.4% |
| 5 | 7 | 1.4% |
| 12 | 6 | 1.2% |
| 7 | 4 | 0.8% |
| 9 | 3 | 0.6% |
| 8 | 2 | 0.4% |
| Other values (4) | 5 | 1.0% |
| Value | Count | Frequency (%) |
| 1 | 303 | |
| 2 | 107 | 21.4% |
| 3 | 28 | 5.6% |
| 4 | 23 | 4.6% |
| 5 | 7 | 1.4% |
| 6 | 12 | 2.4% |
| 7 | 4 | 0.8% |
| 8 | 2 | 0.4% |
| 9 | 3 | 0.6% |
| 10 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 36 | 1 | 0.2% |
| 15 | 1 | 0.2% |
| 14 | 2 | 0.4% |
| 12 | 6 | |
| 10 | 1 | 0.2% |
| 9 | 3 | 0.6% |
| 8 | 2 | 0.4% |
| 7 | 4 | 0.8% |
| 6 | 12 | |
| 5 | 7 |
SalesDollars
Real number (ℝ)
High correlation
| Distinct | 115 |
|---|---|
| Distinct (%) | 23.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.56852 |
| Minimum | 3.99 |
|---|---|
| Maximum | 1007.64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 3.99 |
|---|---|
| 5-th percentile | 8.49 |
| Q1 | 11.365 |
| median | 19.98 |
| Q3 | 33.96 |
| 95-th percentile | 85.98 |
| Maximum | 1007.64 |
| Range | 1003.65 |
| Interquartile range (IQR) | 22.595 |
Descriptive statistics
| Standard deviation | 51.625674 |
|---|---|
| Coefficient of variation (CV) | 1.6888509 |
| Kurtosis | 258.23915 |
| Mean | 30.56852 |
| Median Absolute Deviation (MAD) | 9.99 |
| Skewness | 14.027955 |
| Sum | 15284.26 |
| Variance | 2665.2102 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 9.99 | 40 | 8.0% |
| 10.99 | 35 | 7.0% |
| 8.99 | 16 | 3.2% |
| 16.99 | 16 | 3.2% |
| 19.98 | 15 | 3.0% |
| 8.49 | 15 | 3.0% |
| 11.99 | 14 | 2.8% |
| 14.99 | 14 | 2.8% |
| 20.99 | 13 | 2.6% |
| 27.99 | 13 | 2.6% |
| Other values (105) | 309 |
| Value | Count | Frequency (%) |
| 3.99 | 1 | 0.2% |
| 4.99 | 1 | 0.2% |
| 6.29 | 4 | 0.8% |
| 6.99 | 4 | 0.8% |
| 7.49 | 2 | 0.4% |
| 7.95 | 2 | 0.4% |
| 8.49 | 15 | 3.0% |
| 8.99 | 16 | 3.2% |
| 9.95 | 5 | 1.0% |
| 9.99 | 40 |
| Value | Count | Frequency (%) |
| 1007.64 | 1 | 0.2% |
| 224.85 | 1 | 0.2% |
| 179.94 | 1 | 0.2% |
| 167.88 | 1 | 0.2% |
| 153.86 | 1 | 0.2% |
| 139.9 | 1 | 0.2% |
| 134.91 | 2 | |
| 119.88 | 3 | |
| 118.86 | 1 | 0.2% |
| 113.94 | 1 | 0.2% |
SalesPrice
Real number (ℝ)
High correlation
| Distinct | 43 |
|---|---|
| Distinct (%) | 8.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.966 |
| Minimum | 3.99 |
|---|---|
| Maximum | 99.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 3.99 |
|---|---|
| 5-th percentile | 8.49 |
| Q1 | 9.99 |
| median | 11.99 |
| Q3 | 17.99 |
| 95-th percentile | 34.99 |
| Maximum | 99.99 |
| Range | 96 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 11.109741 |
|---|---|
| Coefficient of variation (CV) | 0.69583748 |
| Kurtosis | 19.126269 |
| Mean | 15.966 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 3.6839041 |
| Sum | 7983 |
| Variance | 123.42635 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=43)
| Value | Count | Frequency (%) |
| 9.99 | 77 | |
| 10.99 | 54 | 10.8% |
| 8.49 | 44 | 8.8% |
| 14.99 | 36 | 7.2% |
| 15.99 | 24 | 4.8% |
| 11.99 | 20 | 4.0% |
| 16.99 | 19 | 3.8% |
| 8.99 | 19 | 3.8% |
| 27.99 | 18 | 3.6% |
| 12.99 | 17 | 3.4% |
| Other values (33) | 172 |
| Value | Count | Frequency (%) |
| 3.99 | 1 | 0.2% |
| 4.99 | 2 | 0.4% |
| 6.29 | 8 | 1.6% |
| 6.99 | 7 | 1.4% |
| 7.49 | 3 | 0.6% |
| 7.95 | 2 | 0.4% |
| 8.49 | 44 | |
| 8.99 | 19 | 3.8% |
| 9.95 | 6 | 1.2% |
| 9.99 | 77 |
| Value | Count | Frequency (%) |
| 99.99 | 2 | |
| 74.99 | 4 | |
| 62.99 | 1 | 0.2% |
| 58.99 | 1 | 0.2% |
| 49.99 | 1 | 0.2% |
| 46.99 | 1 | 0.2% |
| 44.99 | 2 | |
| 42.99 | 4 | |
| 39.99 | 4 | |
| 35.99 | 1 | 0.2% |
SalesDate
Categorical
| Distinct | 31 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.9 KiB |
| 2024-01-23 | 30 |
|---|---|
| 2024-01-09 | 29 |
| 2024-01-15 | 28 |
| 2024-01-29 | 28 |
| 2024-01-30 | 24 |
| Other values (26) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2024-01-01 |
|---|---|
| 2nd row | 2024-01-02 |
| 3rd row | 2024-01-03 |
| 4th row | 2024-01-08 |
| 5th row | 2024-01-09 |
Common Values
| Value | Count | Frequency (%) |
| 2024-01-23 | 30 | 6.0% |
| 2024-01-09 | 29 | 5.8% |
| 2024-01-15 | 28 | 5.6% |
| 2024-01-29 | 28 | 5.6% |
| 2024-01-30 | 24 | 4.8% |
| 2024-01-22 | 23 | 4.6% |
| 2024-01-02 | 23 | 4.6% |
| 2024-01-06 | 21 | 4.2% |
| 2024-01-07 | 20 | 4.0% |
| 2024-01-20 | 19 | 3.8% |
| Other values (21) | 255 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2024-01-23 | 30 | 6.0% |
| 2024-01-09 | 29 | 5.8% |
| 2024-01-15 | 28 | 5.6% |
| 2024-01-29 | 28 | 5.6% |
| 2024-01-30 | 24 | 4.8% |
| 2024-01-22 | 23 | 4.6% |
| 2024-01-02 | 23 | 4.6% |
| 2024-01-06 | 21 | 4.2% |
| 2024-01-07 | 20 | 4.0% |
| 2024-01-20 | 19 | 3.8% |
| Other values (21) | 255 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 1234 | |
| 0 | 1216 | |
| - | 1000 | |
| 1 | 667 | |
| 4 | 532 | |
| 3 | 96 | 1.9% |
| 9 | 64 | 1.3% |
| 6 | 51 | 1.0% |
| 5 | 50 | 1.0% |
| 7 | 49 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1234 | |
| 0 | 1216 | |
| - | 1000 | |
| 1 | 667 | |
| 4 | 532 | |
| 3 | 96 | 1.9% |
| 9 | 64 | 1.3% |
| 6 | 51 | 1.0% |
| 5 | 50 | 1.0% |
| 7 | 49 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1234 | |
| 0 | 1216 | |
| - | 1000 | |
| 1 | 667 | |
| 4 | 532 | |
| 3 | 96 | 1.9% |
| 9 | 64 | 1.3% |
| 6 | 51 | 1.0% |
| 5 | 50 | 1.0% |
| 7 | 49 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1234 | |
| 0 | 1216 | |
| - | 1000 | |
| 1 | 667 | |
| 4 | 532 | |
| 3 | 96 | 1.9% |
| 9 | 64 | 1.3% |
| 6 | 51 | 1.0% |
| 5 | 50 | 1.0% |
| 7 | 49 | 1.0% |
Volume
Real number (ℝ)
High correlation
| Distinct | 9 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 929.05 |
| Minimum | 50 |
|---|---|
| Maximum | 5000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 750 |
| Q1 | 750 |
| median | 750 |
| Q3 | 750 |
| 95-th percentile | 1750 |
| Maximum | 5000 |
| Range | 4950 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 630.03272 |
|---|---|
| Coefficient of variation (CV) | 0.67814727 |
| Kurtosis | 29.04688 |
| Mean | 929.05 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.9829727 |
| Sum | 464525 |
| Variance | 396941.23 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 750 | 395 | |
| 1500 | 45 | 9.0% |
| 1750 | 21 | 4.2% |
| 1000 | 16 | 3.2% |
| 5000 | 9 | 1.8% |
| 375 | 5 | 1.0% |
| 200 | 4 | 0.8% |
| 50 | 3 | 0.6% |
| 100 | 2 | 0.4% |
| Value | Count | Frequency (%) |
| 50 | 3 | 0.6% |
| 100 | 2 | 0.4% |
| 200 | 4 | 0.8% |
| 375 | 5 | 1.0% |
| 750 | 395 | |
| 1000 | 16 | 3.2% |
| 1500 | 45 | 9.0% |
| 1750 | 21 | 4.2% |
| 5000 | 9 | 1.8% |
| Value | Count | Frequency (%) |
| 5000 | 9 | 1.8% |
| 1750 | 21 | 4.2% |
| 1500 | 45 | 9.0% |
| 1000 | 16 | 3.2% |
| 750 | 395 | |
| 375 | 5 | 1.0% |
| 200 | 4 | 0.8% |
| 100 | 2 | 0.4% |
| 50 | 3 | 0.6% |
Classification
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 24.5 KiB |
| 2 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 388 | |
| 1 | 112 | 22.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 388 | |
| 1 | 112 | 22.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 388 | |
| 1 | 112 | 22.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 388 | |
| 1 | 112 | 22.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 388 | |
| 1 | 112 | 22.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 388 | |
| 1 | 112 | 22.4% |
ExciseTax
Real number (ℝ)
High correlation
| Distinct | 31 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6151 |
| Minimum | 0.05 |
|---|---|
| Maximum | 28.35 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0.05 |
|---|---|
| 5-th percentile | 0.11 |
| Q1 | 0.11 |
| median | 0.22 |
| Q3 | 0.75 |
| 95-th percentile | 1.84 |
| Maximum | 28.35 |
| Range | 28.3 |
| Interquartile range (IQR) | 0.64 |
Descriptive statistics
| Standard deviation | 1.6167603 |
|---|---|
| Coefficient of variation (CV) | 2.6284512 |
| Kurtosis | 180.15935 |
| Mean | 0.6151 |
| Median Absolute Deviation (MAD) | 0.11 |
| Skewness | 11.635322 |
| Sum | 307.55 |
| Variance | 2.613914 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) |
| 0.11 | 184 | |
| 0.22 | 102 | |
| 0.79 | 56 | 11.2% |
| 0.45 | 29 | 5.8% |
| 0.34 | 25 | 5.0% |
| 0.68 | 13 | 2.6% |
| 1.05 | 13 | 2.6% |
| 1.57 | 9 | 1.8% |
| 3.67 | 8 | 1.6% |
| 1.84 | 8 | 1.6% |
| Other values (21) | 53 | 10.6% |
| Value | Count | Frequency (%) |
| 0.05 | 3 | 0.6% |
| 0.1 | 2 | 0.4% |
| 0.11 | 184 | |
| 0.21 | 3 | 0.6% |
| 0.22 | 102 | |
| 0.34 | 25 | 5.0% |
| 0.39 | 4 | 0.8% |
| 0.42 | 1 | 0.2% |
| 0.45 | 29 | 5.8% |
| 0.56 | 5 | 1.0% |
| Value | Count | Frequency (%) |
| 28.35 | 1 | 0.2% |
| 11.02 | 1 | 0.2% |
| 9.45 | 1 | 0.2% |
| 7.35 | 3 | 0.6% |
| 5.51 | 1 | 0.2% |
| 3.67 | 8 | |
| 3.15 | 1 | 0.2% |
| 2.1 | 3 | 0.6% |
| 2.02 | 1 | 0.2% |
| 1.84 | 8 |
VendorNo
Real number (ℝ)
High correlation
| Distinct | 26 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7177.68 |
| Minimum | 480 |
|---|---|
| Maximum | 90046 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 480 |
|---|---|
| 5-th percentile | 1392 |
| Q1 | 3252 |
| median | 7153 |
| Q3 | 9744 |
| 95-th percentile | 12546 |
| Maximum | 90046 |
| Range | 89566 |
| Interquartile range (IQR) | 6492 |
Descriptive statistics
| Standard deviation | 8294.0517 |
|---|---|
| Coefficient of variation (CV) | 1.1555338 |
| Kurtosis | 77.859093 |
| Mean | 7177.68 |
| Median Absolute Deviation (MAD) | 2728 |
| Skewness | 8.0067093 |
| Sum | 3588840 |
| Variance | 68791294 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=26)
| Value | Count | Frequency (%) |
| 4425 | 76 | |
| 3252 | 58 | |
| 9815 | 52 | |
| 2000 | 33 | 6.6% |
| 9552 | 32 | 6.4% |
| 3924 | 32 | 6.4% |
| 7153 | 29 | 5.8% |
| 10754 | 24 | 4.8% |
| 1392 | 21 | 4.2% |
| 9165 | 21 | 4.2% |
| Other values (16) | 122 |
| Value | Count | Frequency (%) |
| 480 | 1 | 0.2% |
| 516 | 6 | 1.2% |
| 1128 | 10 | 2.0% |
| 1392 | 21 | 4.2% |
| 1590 | 3 | 0.6% |
| 2000 | 33 | |
| 2555 | 2 | 0.4% |
| 3252 | 58 | |
| 3664 | 2 | 0.4% |
| 3924 | 32 |
| Value | Count | Frequency (%) |
| 90046 | 1 | 0.2% |
| 90024 | 3 | 0.6% |
| 17035 | 10 | 2.0% |
| 12546 | 18 | 3.6% |
| 10754 | 24 | |
| 9819 | 5 | 1.0% |
| 9815 | 52 | |
| 9744 | 18 | 3.6% |
| 9552 | 32 | |
| 9165 | 21 |
VendorName
Categorical
High correlation
| Distinct | 26 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 36.8 KiB |
| MARTIGNETTI COMPANIES | |
|---|---|
| E & J GALLO WINERY | |
| WINE GROUP INC | |
| SOUTHERN WINE & SPIRITS NE | |
| M S WALKER INC | |
| Other values (21) |
Length
| Max length | 27 |
|---|---|
| Median length | 27 |
| Mean length | 26.088 |
| Min length | 21 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | JIM BEAM BRANDS COMPANY |
|---|---|
| 2nd row | JIM BEAM BRANDS COMPANY |
| 3rd row | JIM BEAM BRANDS COMPANY |
| 4th row | JIM BEAM BRANDS COMPANY |
| 5th row | JIM BEAM BRANDS COMPANY |
Common Values
| Value | Count | Frequency (%) |
| MARTIGNETTI COMPANIES | 76 | |
| E & J GALLO WINERY | 58 | |
| WINE GROUP INC | 52 | |
| SOUTHERN WINE & SPIRITS NE | 33 | 6.6% |
| M S WALKER INC | 32 | 6.4% |
| HEAVEN HILL DISTILLERIES | 32 | 6.4% |
| PINE STATE TRADING CO | 29 | 5.8% |
| PERFECTA WINES | 24 | 4.8% |
| CONSTELLATION BRANDS INC | 21 | 4.2% |
| ULTRA BEVERAGE COMPANY LLP | 21 | 4.2% |
| Other values (16) | 122 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| inc | 144 | 8.5% |
| 111 | 6.6% | |
| wine | 90 | 5.3% |
| companies | 76 | 4.5% |
| martignetti | 76 | 4.5% |
| e | 58 | 3.4% |
| j | 58 | 3.4% |
| winery | 58 | 3.4% |
| gallo | 58 | 3.4% |
| group | 52 | 3.1% |
| Other values (53) | 907 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4441 | ||
| E | 958 | 7.3% |
| I | 938 | 7.2% |
| N | 876 | 6.7% |
| A | 644 | 4.9% |
| R | 596 | 4.6% |
| T | 574 | 4.4% |
| S | 530 | 4.1% |
| O | 456 | 3.5% |
| L | 438 | 3.4% |
| Other values (18) | 2593 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 13044 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4441 | ||
| E | 958 | 7.3% |
| I | 938 | 7.2% |
| N | 876 | 6.7% |
| A | 644 | 4.9% |
| R | 596 | 4.6% |
| T | 574 | 4.4% |
| S | 530 | 4.1% |
| O | 456 | 3.5% |
| L | 438 | 3.4% |
| Other values (18) | 2593 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 13044 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4441 | ||
| E | 958 | 7.3% |
| I | 938 | 7.2% |
| N | 876 | 6.7% |
| A | 644 | 4.9% |
| R | 596 | 4.6% |
| T | 574 | 4.4% |
| S | 530 | 4.1% |
| O | 456 | 3.5% |
| L | 438 | 3.4% |
| Other values (18) | 2593 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 13044 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4441 | ||
| E | 958 | 7.3% |
| I | 938 | 7.2% |
| N | 876 | 6.7% |
| A | 644 | 4.9% |
| R | 596 | 4.6% |
| T | 574 | 4.4% |
| S | 530 | 4.1% |
| O | 456 | 3.5% |
| L | 438 | 3.4% |
| Other values (18) | 2593 |
Interactions
Correlations
| Brand | Classification | ExciseTax | SalesDate | SalesDollars | SalesPrice | SalesQuantity | Size | VendorName | VendorNo | Volume | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Brand | 1.000 | 0.999 | -0.384 | 0.000 | -0.144 | -0.489 | 0.199 | 0.447 | 0.757 | 0.046 | -0.061 |
| Classification | 0.999 | 1.000 | 0.327 | 0.000 | 0.051 | 0.471 | 0.115 | 0.645 | 0.970 | 0.058 | 0.522 |
| ExciseTax | -0.384 | 0.327 | 1.000 | 0.000 | 0.608 | 0.262 | 0.510 | 0.334 | 0.193 | -0.042 | 0.423 |
| SalesDate | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.043 | 0.000 | 0.000 | 0.000 | 0.000 |
| SalesDollars | -0.144 | 0.051 | 0.608 | 0.000 | 1.000 | 0.550 | 0.697 | 0.000 | 0.000 | -0.103 | 0.014 |
| SalesPrice | -0.489 | 0.471 | 0.262 | 0.000 | 0.550 | 1.000 | -0.144 | 0.429 | 0.429 | -0.185 | 0.066 |
| SalesQuantity | 0.199 | 0.115 | 0.510 | 0.043 | 0.697 | -0.144 | 1.000 | 0.000 | 0.068 | -0.016 | 0.022 |
| Size | 0.447 | 0.645 | 0.334 | 0.000 | 0.000 | 0.429 | 0.000 | 1.000 | 0.509 | 0.221 | 0.992 |
| VendorName | 0.757 | 0.970 | 0.193 | 0.000 | 0.000 | 0.429 | 0.068 | 0.509 | 1.000 | 0.977 | 0.521 |
| VendorNo | 0.046 | 0.058 | -0.042 | 0.000 | -0.103 | -0.185 | -0.016 | 0.221 | 0.977 | 1.000 | -0.283 |
| Volume | -0.061 | 0.522 | 0.423 | 0.000 | 0.014 | 0.066 | 0.022 | 0.992 | 0.521 | -0.283 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| InventoryId | Store | Brand | Description | Size | SalesQuantity | SalesDollars | SalesPrice | SalesDate | Volume | Classification | ExciseTax | VendorNo | VendorName | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1_HARDERSFIELD_1004 | 1 | 1004 | Jim Beam w/2 Rocks Glasses | 750mL | 1 | 16.49 | 16.49 | 2024-01-01 | 750.0 | 1 | 0.79 | 12546 | JIM BEAM BRANDS COMPANY |
| 1 | 1_HARDERSFIELD_1004 | 1 | 1004 | Jim Beam w/2 Rocks Glasses | 750mL | 2 | 32.98 | 16.49 | 2024-01-02 | 750.0 | 1 | 1.57 | 12546 | JIM BEAM BRANDS COMPANY |
| 2 | 1_HARDERSFIELD_1004 | 1 | 1004 | Jim Beam w/2 Rocks Glasses | 750mL | 1 | 16.49 | 16.49 | 2024-01-03 | 750.0 | 1 | 0.79 | 12546 | JIM BEAM BRANDS COMPANY |
| 3 | 1_HARDERSFIELD_1004 | 1 | 1004 | Jim Beam w/2 Rocks Glasses | 750mL | 1 | 14.49 | 14.49 | 2024-01-08 | 750.0 | 1 | 0.79 | 12546 | JIM BEAM BRANDS COMPANY |
| 4 | 1_HARDERSFIELD_1005 | 1 | 1005 | Maker's Mark Combo Pack | 375mL 2 Pk | 2 | 69.98 | 34.99 | 2024-01-09 | 375.0 | 1 | 0.79 | 12546 | JIM BEAM BRANDS COMPANY |
| 5 | 1_HARDERSFIELD_1005 | 1 | 1005 | Maker's Mark Combo Pack | 375mL 2 Pk | 1 | 34.99 | 34.99 | 2024-01-15 | 375.0 | 1 | 0.39 | 12546 | JIM BEAM BRANDS COMPANY |
| 6 | 1_HARDERSFIELD_1005 | 1 | 1005 | Maker's Mark Combo Pack | 375mL 2 Pk | 1 | 34.99 | 34.99 | 2024-01-22 | 375.0 | 1 | 0.39 | 12546 | JIM BEAM BRANDS COMPANY |
| 7 | 1_HARDERSFIELD_1005 | 1 | 1005 | Maker's Mark Combo Pack | 375mL 2 Pk | 1 | 34.99 | 34.99 | 2024-01-30 | 375.0 | 1 | 0.39 | 12546 | JIM BEAM BRANDS COMPANY |
| 8 | 1_HARDERSFIELD_10058 | 1 | 10058 | F Coppola Dmd Ivry Cab Svgn | 750mL | 4 | 59.96 | 14.99 | 2024-01-05 | 750.0 | 2 | 0.45 | 2000 | SOUTHERN WINE & SPIRITS NE |
| 9 | 1_HARDERSFIELD_10058 | 1 | 10058 | F Coppola Dmd Ivry Cab Svgn | 750mL | 1 | 14.99 | 14.99 | 2024-01-06 | 750.0 | 2 | 0.11 | 2000 | SOUTHERN WINE & SPIRITS NE |
| InventoryId | Store | Brand | Description | Size | SalesQuantity | SalesDollars | SalesPrice | SalesDate | Volume | Classification | ExciseTax | VendorNo | VendorName | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 490 | 1_HARDERSFIELD_11828 | 1 | 11828 | Cupcake Svgn Bl | 750mL | 7 | 59.43 | 8.49 | 2024-01-23 | 750.0 | 2 | 0.79 | 9815 | WINE GROUP INC |
| 491 | 1_HARDERSFIELD_11828 | 1 | 11828 | Cupcake Svgn Bl | 750mL | 2 | 16.98 | 8.49 | 2024-01-24 | 750.0 | 2 | 0.22 | 9815 | WINE GROUP INC |
| 492 | 1_HARDERSFIELD_11828 | 1 | 11828 | Cupcake Svgn Bl | 750mL | 2 | 16.98 | 8.49 | 2024-01-28 | 750.0 | 2 | 0.22 | 9815 | WINE GROUP INC |
| 493 | 1_HARDERSFIELD_11828 | 1 | 11828 | Cupcake Svgn Bl | 750mL | 2 | 16.98 | 8.49 | 2024-01-30 | 750.0 | 2 | 0.22 | 9815 | WINE GROUP INC |
| 494 | 1_HARDERSFIELD_1186 | 1 | 1186 | Evan Williams Single Barrel | 750mL | 1 | 27.99 | 27.99 | 2024-01-18 | 750.0 | 1 | 0.79 | 3924 | HEAVEN HILL DISTILLERIES |
| 495 | 1_HARDERSFIELD_11888 | 1 | 11888 | Penfolds Koonunga Hills Shir | 750mL | 1 | 10.99 | 10.99 | 2024-01-01 | 750.0 | 2 | 0.11 | 4425 | MARTIGNETTI COMPANIES |
| 496 | 1_HARDERSFIELD_11888 | 1 | 11888 | Penfolds Koonunga Hills Shir | 750mL | 1 | 10.99 | 10.99 | 2024-01-02 | 750.0 | 2 | 0.11 | 4425 | MARTIGNETTI COMPANIES |
| 497 | 1_HARDERSFIELD_11888 | 1 | 11888 | Penfolds Koonunga Hills Shir | 750mL | 1 | 10.99 | 10.99 | 2024-01-09 | 750.0 | 2 | 0.11 | 4425 | MARTIGNETTI COMPANIES |
| 498 | 1_HARDERSFIELD_11888 | 1 | 11888 | Penfolds Koonunga Hills Shir | 750mL | 1 | 10.99 | 10.99 | 2024-01-13 | 750.0 | 2 | 0.11 | 4425 | MARTIGNETTI COMPANIES |
| 499 | 1_HARDERSFIELD_11888 | 1 | 11888 | Penfolds Koonunga Hills Shir | 750mL | 2 | 21.98 | 10.99 | 2024-01-15 | 750.0 | 2 | 0.22 | 4425 | MARTIGNETTI COMPANIES |